package mobi.hami.huapin.dao;

import mobi.hami.huapin.daobase.CrudMapper;
import mobi.hami.huapin.dto.UserCouponDTO;
import mobi.hami.huapin.model.UserCoupon;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UserCouponMapper extends CrudMapper<UserCoupon> {
    @Select("select * from user_coupon where expiration_time>now() and user_id=#{user_id} and Is_valid=#{is_valid}")
    List<UserCouponDTO> selectListByModel(UserCoupon userCoupon);

}